How can get alternate highest salary or any record in a table in SQL Server ?

Question

Koi Ken · Answer

Post is removed by the Admin.

Anonymous User · Answer

USE DENSE_RANK FUNCTION for this operation.and MSSQL DENSE_RANK FUNCTION SYNTAXDENSE_RANK ( ) OVER ( [ andlt;partition_by_clauseandgt; ] andlt;order_by_clauseandgt; )

Name	RollNo	Marks
A	1	40
B	2	50
C	3	55
D	4	48
E	6	66

forum

How can get alternate highest salary or any record in a table in SQL Server ?

Anonymous User

Can you answer this question?

2 Answers

Liked By